Overview

Dataset info

Number of variables94
Number of observations137
Missing cells1916 (14.9%)
Duplicate rows0 (0.0%)
Total size in memory100.7 KiB
Average record size in memory752.6 B

Variables types

Numeric3
Categorical15
Boolean4
Date0
URL0
Text (Unique)0
Rejected72
Unsupported0

Warnings

AGGR_POL_TERM_LIMIT_AMT has 39 (28.5%) missing values Missing
AMOUNT_CATEGORY_1_DESC has constant value "Premium" Rejected
AMOUNT_CATEGORY_2_DESC has constant value "Written" Rejected
AMOUNT_CATEGORY_3_DESC has constant value "nan" Rejected
ANNUAL_STMT_LINE_NAIC_CODE has constant value "90" Rejected
BLANKET_COVERAGE_IND has constant value "nan" Rejected
BUREAU_LINE_CODE has constant value "61" Rejected
BUREAU_REPORTING_MODULE has constant value "Inland Marine" Rejected
CANCEL_NO_RENEW_REASON_CODE has constant value "0" Rejected
CANCELLATION_TYPE has constant value "NON CANCEL" Rejected
CHANGE_WRITTEN_PREMIUM has 103 (75.2%) zeros Zeros
CLAIMS_MADE_IND has constant value "0" Rejected
CLASS_CODE has constant value "379" Rejected
CMRCL_DEREG_EXEMPT_IND has constant value "0" Rejected
COMPANY_CODE has constant value "1" Rejected
COUNTRY_CODE has constant value "CAN" Rejected
COVERAGE_INCEPTION_DATE has constant value "16-SEP-19" Rejected
CURRENT_PROFIT_CENTER has constant value "3542" Rejected
DEDUCT_AMT has 8 (5.8%) missing values Missing
DEDUCTIBLE_CODE is highly correlated with DEDUCT_AMT (ρ = 1) Rejected
DEDUCTIBLE_PURPOSE_DESC has 113 (82.5%) missing values Missing
EARN_EXPIRATION_DATE has constant value "16-SEP-20" Rejected
EXPENSE_MODIFIER has constant value "nan" Rejected
EXPIRATION_DATE has constant value "16-SEP-20" Rejected
EXPOSURE has 47 (34.3%) zeros Zeros
HSB_COVERAGE_CD has constant value "0" Rejected
INSURED_CITY_STATE has constant value "TORONTO, ON" Rejected
INSURED_NAME has constant value "BETA UAT PM QA TEST" Rejected
INSURED_ZIPCODE has constant value "111 BBB" Rejected
INTERNAL_ANNUAL_STMT_LINE_CODE has constant value "90" Rejected
INTERNAL_ANNUAL_STMT_LINE_CODE_1 has constant value "90" Rejected
ISO_PREMIUM_TERROR_CD has constant value "nan" Rejected
ISO_REPORTING_TERRITORY_CD has constant value "nan" Rejected
ISO_UNDERLYING_CD has 5 (3.6%) missing values Missing
LEGACY_PRO_CD has constant value "D" Rejected
LOCATION_UNIT_NUMBER is highly correlated with CONSTRUCTION_TYPE (ρ = 1) Rejected
LOSS_COST_MODIFIER has constant value "nan" Rejected
MINOR_LINE_CODE has constant value "90" Rejected
NAICS_CODE has constant value "236220" Rejected
NO_OF_FAMILIES has constant value "1" Rejected
NY_FREE_TRADE_ZONE_CD has constant value "0" Rejected
ONCORE_INDICATOR has constant value "BRIDGE-PAS" Rejected
PACKAGE_MODIFICATION_FACTOR has constant value "nan" Rejected
PER_OCCUR_LIMIT_AMT has 39 (28.5%) missing values Missing
POL_LIMIT_AMT has 39 (28.5%) missing values Missing
POLICY_EFFECTIVE_DATE has constant value "16-SEP-19" Rejected
POLICY_MODULE has constant value "0" Rejected
POLICY_NUMBER has constant value "2509018" Rejected
POLICY_STATE has constant value "82" Rejected
POLICY_STATUS has constant value "INFORCE" Rejected
POLICY_SYMBOL has constant value "IMP" Rejected
POLICY_TERM has constant value "12" Rejected
POLICY_VERSION_CD has constant value "0" Rejected
PREM_BILLING_CATEGORY_41_CODE has constant value "M" Rejected
PREM_TRNSCTN_CATEGORY_35_CODE is a recoding of BUSINESS_ACTIVITY_CODERejected
PREMIUM_TRNSCTN_DAC_CODE has constant value "1" Rejected
PRODUCER_A_CODE has constant value "264303" Rejected
PRODUCT_VALUE_1_8_CODE has constant value "2626AA04" Rejected
PROTECTION_CODE has constant value "0" Rejected
RATE_BASIS has 132 (96.4%) missing values Missing
RATE_DEPARTURE_FACTOR has constant value "0" Rejected
RATE_MOD_FACTOR_EXPENSE has constant value "0" Rejected
RATE_MOD_FACTOR_IRPM_SRP has constant value "0" Rejected
RATE_MOD_FACTOR_PACKAGE has constant value "0" Rejected
RATING_METHOD has 132 (96.4%) missing values Missing
RATING_TERRITORY_CD has constant value "nan" Rejected
REIN_TYPE_REPORTING_CATEGORY_1 has constant value "Direct" Rejected
SBP_BLANKET_IND has constant value "0" Rejected
SCHEDULE_MODIFIER has constant value "nan" Rejected
SIC_CODE has constant value "1542000D" Rejected
STAT_FORMAT_CODE has constant value "UIM" Rejected
STATE_PROVINCE_CODE has constant value "AB" Rejected
SUBLINE_CODE has constant value "920" Rejected
SURCHARGE_TYPE has constant value "nan" Rejected
SYSTEM_OF_RECORD_CODE has constant value "BRIDGE-PAS" Rejected
TAX_LOCATION_CODE has constant value "0" Rejected
TERRORISM_CVRG_CD has constant value "TERROR1" Rejected
TRANSACTION_ACCOUNTING_MONTH is highly correlated with SUBMISSION_ID (ρ = 0.9999978206) Rejected
TRANSACTION_ACCOUNTING_YEAR has constant value "2019" Rejected
TRANSACTION_EFFECTIVE_DATE only contains datetime values, but is categorical. Consider applying pd.to_datetime()Type
UNDERLYING_LIMIT_AMT has 39 (28.5%) missing values Missing
UNDERWRITER_CODE_1 has constant value "N" Rejected
UNDERWRITER_CODE_2 has constant value "N" Rejected
ZIP_CODE_FIRST5 has constant value "0" Rejected

Variables

AGGR_POL_TERM_LIMIT_AMT
Boolean

Distinct count2
Unique (%)1.5%
Missing (%)28.5%
Missing (n)39
0
98
(Missing)
39
ValueCountFrequency (%) 
0 98 71.5%
 
(Missing) 39 28.5%
 

AMOUNT_CATEGORY_1_DESC
Constant

This variable is constant and should be ignored for analysis

Constant valuePremium

AMOUNT_CATEGORY_2_DESC
Constant

This variable is constant and should be ignored for analysis

Constant valueWritten

AMOUNT_CATEGORY_3_DESC
Constant

This variable is constant and should be ignored for analysis

Constant valuenan

ANNUAL_STMT_LINE_NAIC_CODE
Constant

This variable is constant and should be ignored for analysis

Constant value90

BLANKET_COVERAGE_IND
Constant

This variable is constant and should be ignored for analysis

Constant valuenan

BUREAU_LINE_CODE
Constant

This variable is constant and should be ignored for analysis

Constant value61

BUREAU_REPORTING_MODULE
Constant

This variable is constant and should be ignored for analysis

Constant valueInland Marine

BUSINESS_ACTIVITY_CODE
Categorical

Distinct count2
Unique (%)1.5%
Missing (%)0.0%
Missing (n)0
ENDT
91
NBP
46
ValueCountFrequency (%) 
ENDT 91 66.4%
 
NBP 46 33.6%
 
Max length4
Mean length3.664233577
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesFalse
Contains non-wordsFalse

CANCEL_NO_RENEW_REASON_CODE
Constant

This variable is constant and should be ignored for analysis

Constant value0

CANCELLATION_TYPE
Constant

This variable is constant and should be ignored for analysis

Constant valueNON CANCEL

CHANGE_WRITTEN_PREMIUM
Numeric

Distinct count15
Unique (%)10.9%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean57.48175182
Minimum-6836
Maximum6836
Zeros (%)75.2%
Mini histogram

Quantile statistics

Minimum-6836
5-th percentile-100
Q10
Median0
Q30
95-th percentile120
Maximum6836
Range13672
Interquartile range0

Descriptive statistics

Standard deviation1295.670971
Coef of variation22.54056166
Kurtosis25.19035247
Mean57.48175182
MAD309.8074485
Skewness0.9608413272
Sum7875
Variance1678763.266
Memory size1.1 KiB
Histogram
Histogram with fixed size bins (bins=15)
Histogram
Histogram with variable size bins (bins=[-6836. -225. -23.5 23.5 225. 6736.5 6836. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 103 75.2%
 
100 8 5.8%
 
47 5 3.6%
 
-100 4 2.9%
 
-47 3 2.2%
 
250 2 1.5%
 
200 2 1.5%
 
6836 2 1.5%
 
95 2 1.5%
 
-250 1 0.7%
 
Other values (5) 5 3.6%
 

Minimum 5 values

ValueCountFrequency (%) 
-6836 1 0.7%
 
-6637 1 0.7%
 
-250 1 0.7%
 
-200 1 0.7%
 
-100 4 2.9%
 

Maximum 5 values

ValueCountFrequency (%) 
6836 2 1.5%
 
6637 1 0.7%
 
250 2 1.5%
 
200 2 1.5%
 
100 8 5.8%
 

CLAIMS_MADE_IND
Constant

This variable is constant and should be ignored for analysis

Constant value0

CLASS_CODE
Constant

This variable is constant and should be ignored for analysis

Constant value379

CMRCL_DEREG_EXEMPT_IND
Constant

This variable is constant and should be ignored for analysis

Constant value0

COMPANY_CODE
Constant

This variable is constant and should be ignored for analysis

Constant value1

CONSTRUCTION_TYPE
Categorical

Distinct count2
Unique (%)1.5%
Missing (%)0.0%
Missing (n)0
0
132
3
 
5
ValueCountFrequency (%) 
0 132 96.4%
 
3 5 3.6%
 
Max length1
Mean length1
Min length1
Contains charsFalse
Contains digitsTrue
Contains spacesFalse
Contains non-wordsFalse

COUNTRY_CODE
Constant

This variable is constant and should be ignored for analysis

Constant valueCAN

COVERAGE_CODE
Categorical

Distinct count30
Unique (%)21.9%
Missing (%)0.0%
Missing (n)0
IMBRRES
 
10
TERROR
 
5
PLANRECS
 
5
Other values (27)
117
ValueCountFrequency (%) 
IMBRRES 10 7.3%
 
TERROR 5 3.6%
 
PLANRECS 5 3.6%
 
IMBRRENV 5 3.6%
 
SCAFFOLDS 5 3.6%
 
REMOVALEXP 5 3.6%
 
GREEN 5 3.6%
 
BMP 5 3.6%
 
SOFTCOST 5 3.6%
 
INFLATION 5 3.6%
 
Other values (20) 82 59.9%
 
Max length10
Mean length7.160583942
Min length2
Contains charsTrue
Contains digitsFalse
Contains spacesFalse
Contains non-wordsFalse

COVERAGE_INCEPTION_DATE
Constant

This variable is constant and should be ignored for analysis

Constant value16-SEP-19

CURRENT_PROFIT_CENTER
Constant

This variable is constant and should be ignored for analysis

Constant value3542

DEDUCT_AMT
Categorical

Distinct count3
Unique (%)2.2%
Missing (%)5.8%
Missing (n)8
0
113
25000
 
16
(Missing)
 
8
ValueCountFrequency (%) 
0 113 82.5%
 
25000 16 11.7%
 
(Missing) 8 5.8%
 
Max length7
Mean length3.467153285
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

DEDUCT_APPLIES_TO
Categorical

Distinct count4
Unique (%)2.9%
Missing (%)0.0%
Missing (n)0
0
113
Each Loss
 
14
All other deductibles
 
5
ValueCountFrequency (%) 
0 113 82.5%
 
Each Loss 14 10.2%
 
All other deductibles 5 3.6%
 
All Losses 5 3.6%
 
Max length21
Mean length2.875912409
Min length1
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

DEDUCTIBLE_CODE
Highly correlated

This variable is highly correlated with DEDUCT_AMT and should be ignored for analysis

Correlation1

DEDUCTIBLE_PURPOSE_DESC
Categorical

Distinct count2
Unique (%)1.5%
Missing (%)82.5%
Missing (n)113
(none)
24
(Missing)
113
ValueCountFrequency (%) 
(none) 24 17.5%
 
(Missing) 113 82.5%
 
Max length6
Mean length3.525547445
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesFalse
Contains non-wordsTrue

EARN_EXPIRATION_DATE
Constant

This variable is constant and should be ignored for analysis

Constant value16-SEP-20

EXPENSE_MODIFIER
Constant

This variable is constant and should be ignored for analysis

Constant valuenan

EXPIRATION_DATE
Constant

This variable is constant and should be ignored for analysis

Constant value16-SEP-20

EXPOSURE
Numeric

Distinct count17
Unique (%)12.4%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean275
Minimum-7001
Maximum7001
Zeros (%)34.3%
Mini histogram

Quantile statistics

Minimum-7001
5-th percentile-2200.2
Q10
Median0
Q350
95-th percentile7001
Maximum7001
Range14002
Interquartile range50

Descriptive statistics

Standard deviation2608.789152
Coef of variation9.486506006
Kurtosis4.262824086
Mean275
MAD1208.934307
Skewness0.399475129
Sum37675
Variance6805780.838
Memory size1.1 KiB
Histogram
Histogram with fixed size bins (bins=17)
Histogram
Histogram with variable size bins (bins=[-7.001e+03 -1.750e+02 -5.000e+00 5.000e+00 1.750e+02 7.001e+03], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 47 34.3%
 
100 14 10.2%
 
50 13 9.5%
 
7001 12 8.8%
 
-100 9 6.6%
 
-50 8 5.8%
 
-7001 7 5.1%
 
25 5 3.6%
 
10 5 3.6%
 
-25 3 2.2%
 
Other values (7) 14 10.2%
 

Minimum 5 values

ValueCountFrequency (%) 
-7001 7 5.1%
 
-1000 1 0.7%
 
-600 1 0.7%
 
-250 2 1.5%
 
-100 9 6.6%
 

Maximum 5 values

ValueCountFrequency (%) 
7001 12 8.8%
 
1000 2 1.5%
 
600 2 1.5%
 
250 3 2.2%
 
100 14 10.2%
 

HSB_COVERAGE_CD
Constant

This variable is constant and should be ignored for analysis

Constant value0

INSURED_CITY_STATE
Constant

This variable is constant and should be ignored for analysis

Constant valueTORONTO, ON

INSURED_NAME
Constant

This variable is constant and should be ignored for analysis

Constant valueBETA UAT PM QA TEST

INSURED_ZIPCODE
Constant

This variable is constant and should be ignored for analysis

Constant value111 BBB

INTERNAL_ANNUAL_STMT_LINE_CODE
Constant

This variable is constant and should be ignored for analysis

Constant value90

INTERNAL_ANNUAL_STMT_LINE_CODE_1
Constant

This variable is constant and should be ignored for analysis

Constant value90

ISO_PREMIUM_TERROR_CD
Constant

This variable is constant and should be ignored for analysis

Constant valuenan

ISO_REPORTING_TERRITORY_CD
Constant

This variable is constant and should be ignored for analysis

Constant valuenan

ISO_UNDERLYING_CD
Categorical

Distinct count2
Unique (%)1.5%
Missing (%)3.6%
Missing (n)5
2
132
(Missing)
 
5
ValueCountFrequency (%) 
2 132 96.4%
 
(Missing) 5 3.6%
 
Max length3
Mean length3
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

LEGACY_PRO_CD
Constant

This variable is constant and should be ignored for analysis

Constant valueD

LOCATION_UNIT_NUMBER
Highly correlated

This variable is highly correlated with CONSTRUCTION_TYPE and should be ignored for analysis

Correlation1

LOSS_COST_MODIFIER
Constant

This variable is constant and should be ignored for analysis

Constant valuenan

MINOR_LINE_CODE
Constant

This variable is constant and should be ignored for analysis

Constant value90

NAICS_CODE
Constant

This variable is constant and should be ignored for analysis

Constant value236220

NO_OF_FAMILIES
Constant

This variable is constant and should be ignored for analysis

Constant value1

NY_FREE_TRADE_ZONE_CD
Constant

This variable is constant and should be ignored for analysis

Constant value0

ONCORE_INDICATOR
Constant

This variable is constant and should be ignored for analysis

Constant valueBRIDGE-PAS

ONSET_IND
Boolean

Distinct count2
Unique (%)1.5%
Missing (%)0.0%
Missing (n)0
1
84
0
53
ValueCountFrequency (%) 
1 84 61.3%
 
0 53 38.7%
 

PACKAGE_CODE
Categorical

Distinct count2
Unique (%)1.5%
Missing (%)0.0%
Missing (n)0
26
132
22
 
5
ValueCountFrequency (%) 
26 132 96.4%
 
22 5 3.6%
 
Max length2
Mean length2
Min length2
Contains charsFalse
Contains digitsTrue
Contains spacesFalse
Contains non-wordsFalse

PACKAGE_MODIFICATION_FACTOR
Constant

This variable is constant and should be ignored for analysis

Constant valuenan

PARENT_BUSN_CVRG_CD
Categorical

Distinct count6
Unique (%)4.4%
Missing (%)0.0%
Missing (n)0
IMBRPLUS
46
IMBRRES
33
IMBR
25
Other values (3)
33
ValueCountFrequency (%) 
IMBRPLUS 46 33.6%
 
IMBRRES 33 24.1%
 
IMBR 25 18.2%
 
IMBRUILOB 15 10.9%
 
IMBRRENV 10 7.3%
 
TE 8 5.8%
 
Max length9
Mean length6.788321168
Min length2
Contains charsTrue
Contains digitsFalse
Contains spacesFalse
Contains non-wordsFalse

PER_OCCUR_LIMIT_AMT
Boolean

Distinct count2
Unique (%)1.5%
Missing (%)28.5%
Missing (n)39
0
98
(Missing)
39
ValueCountFrequency (%) 
0 98 71.5%
 
(Missing) 39 28.5%
 

POL_LIMIT_AMT
Numeric

Distinct count9
Unique (%)6.6%
Missing (%)28.5%
Missing (n)39
Infinite (%)0.0%
Infinite (n)0
Mean1464275.316
Minimum10000
Maximum7000999
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum10000
5-th percentile10000
Q150000
Median100000
Q3512500
95-th percentile7000999
Maximum7000999
Range6990999
Interquartile range462500

Descriptive statistics

Standard deviation2735608.146
Coef of variation1.868233464
Kurtosis0.4552166227
Mean1464275.316
MAD2146892.857
Skewness1.556139255
Sum143498981
Variance7.48355193e+12
Memory size1.1 KiB
Histogram
Histogram with fixed size bins (bins=9)
ValueCountFrequency (%) 
100000 31 22.6%
 
50000 21 15.3%
 
7000999 19 13.9%
 
25000 8 5.8%
 
10000 8 5.8%
 
250000 5 3.6%
 
600000 3 2.2%
 
1000000 3 2.2%
 
(Missing) 39 28.5%
 

Minimum 5 values

ValueCountFrequency (%) 
10000 8 5.8%
 
25000 8 5.8%
 
50000 21 15.3%
 
100000 31 22.6%
 
250000 5 3.6%
 

Maximum 5 values

ValueCountFrequency (%) 
7000999 19 13.9%
 
1000000 3 2.2%
 
600000 3 2.2%
 
250000 5 3.6%
 
100000 31 22.6%
 

POLICY_EFFECTIVE_DATE
Constant

This variable is constant and should be ignored for analysis

Constant value16-SEP-19

POLICY_MODULE
Constant

This variable is constant and should be ignored for analysis

Constant value0

POLICY_NUMBER
Constant

This variable is constant and should be ignored for analysis

Constant value2509018

POLICY_STATE
Constant

This variable is constant and should be ignored for analysis

Constant value82

POLICY_STATUS
Constant

This variable is constant and should be ignored for analysis

Constant valueINFORCE

POLICY_SYMBOL
Constant

This variable is constant and should be ignored for analysis

Constant valueIMP

POLICY_TERM
Constant

This variable is constant and should be ignored for analysis

Constant value12

POLICY_VERSION_CD
Constant

This variable is constant and should be ignored for analysis

Constant value0

PREM_BILLING_CATEGORY_41_CODE
Constant

This variable is constant and should be ignored for analysis

Constant valueM

PREM_TRNSCTN_CATEGORY_35_CODE
Recoded

This variable is a recoding of BUSINESS_ACTIVITY_CODE and should be ignored for analysis

PREMIUM_TRNSCTN_DAC_CODE
Constant

This variable is constant and should be ignored for analysis

Constant value1

PRODUCER_A_CODE
Constant

This variable is constant and should be ignored for analysis

Constant value264303

PRODUCT_VALUE_1_8_CODE
Constant

This variable is constant and should be ignored for analysis

Constant value2626AA04

PROTECTION_CODE
Constant

This variable is constant and should be ignored for analysis

Constant value0

RATE_BASIS
Categorical

Distinct count2
Unique (%)1.5%
Missing (%)96.4%
Missing (n)132
Other
 
5
(Missing)
132
ValueCountFrequency (%) 
Other 5 3.6%
 
(Missing) 132 96.4%
 
Max length5
Mean length3.072992701
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesFalse
Contains non-wordsFalse

RATE_DEPARTURE_FACTOR
Constant

This variable is constant and should be ignored for analysis

Constant value0

RATE_MOD_FACTOR_EXPENSE
Constant

This variable is constant and should be ignored for analysis

Constant value0

RATE_MOD_FACTOR_IRPM_SRP
Constant

This variable is constant and should be ignored for analysis

Constant value0

RATE_MOD_FACTOR_PACKAGE
Constant

This variable is constant and should be ignored for analysis

Constant value0

RATING_METHOD
Categorical

Distinct count2
Unique (%)1.5%
Missing (%)96.4%
Missing (n)132
(none)
 
5
(Missing)
132
ValueCountFrequency (%) 
(none) 5 3.6%
 
(Missing) 132 96.4%
 
Max length6
Mean length3.109489051
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesFalse
Contains non-wordsTrue

RATING_TERRITORY_CD
Constant

This variable is constant and should be ignored for analysis

Constant valuenan

REIN_TYPE_REPORTING_CATEGORY_1
Constant

This variable is constant and should be ignored for analysis

Constant valueDirect

RISK_CATG_CD
Categorical

Distinct count4
Unique (%)2.9%
Missing (%)0.0%
Missing (n)0
COVPROP
79
JOBSITE
25
TIMELEMENT
18
ValueCountFrequency (%) 
COVPROP 79 57.7%
 
JOBSITE 25 18.2%
 
TIMELEMENT 18 13.1%
 
BROPS 15 10.9%
 
Max length10
Mean length7.175182482
Min length5
Contains charsTrue
Contains digitsFalse
Contains spacesFalse
Contains non-wordsFalse

SBP_BLANKET_IND
Constant

This variable is constant and should be ignored for analysis

Constant value0

SCHEDULE_MODIFIER
Constant

This variable is constant and should be ignored for analysis

Constant valuenan

SIC_CODE
Constant

This variable is constant and should be ignored for analysis

Constant value1542000D

STAT_FORMAT_CODE
Constant

This variable is constant and should be ignored for analysis

Constant valueUIM

STATE_PROVINCE_CODE
Constant

This variable is constant and should be ignored for analysis

Constant valueAB

SUBLINE_CODE
Constant

This variable is constant and should be ignored for analysis

Constant value920

SUBMISSION_ID
Categorical

Distinct count3
Unique (%)2.2%
Missing (%)0.0%
Missing (n)0
957051
60
957039
54
950041
23
ValueCountFrequency (%) 
957051 60 43.8%
 
957039 54 39.4%
 
950041 23 16.8%
 
Max length6
Mean length6
Min length6
Contains charsFalse
Contains digitsTrue
Contains spacesFalse
Contains non-wordsFalse

SURCHARGE_TYPE
Constant

This variable is constant and should be ignored for analysis

Constant valuenan

SYSTEM_OF_RECORD_CODE
Constant

This variable is constant and should be ignored for analysis

Constant valueBRIDGE-PAS

TAX_LOCATION_CODE
Constant

This variable is constant and should be ignored for analysis

Constant value0

TERRORISM_CVRG_CD
Constant

This variable is constant and should be ignored for analysis

Constant valueTERROR1

TRANS_TYPE_CODE
Categorical

Distinct count2
Unique (%)1.5%
Missing (%)0.0%
Missing (n)0
1
132
2
 
5
ValueCountFrequency (%) 
1 132 96.4%
 
2 5 3.6%
 
Max length1
Mean length1
Min length1
Contains charsFalse
Contains digitsTrue
Contains spacesFalse
Contains non-wordsFalse

TRANSACTION_ACCOUNTING_MONTH
Highly correlated

This variable is highly correlated with SUBMISSION_ID and should be ignored for analysis

Correlation0.9999978206

TRANSACTION_ACCOUNTING_YEAR
Constant

This variable is constant and should be ignored for analysis

Constant value2019

TRANSACTION_EFFECTIVE_DATE
Categorical

Distinct count2
Unique (%)1.5%
Missing (%)0.0%
Missing (n)0
16-SEP-19
77
01-OCT-19
60
ValueCountFrequency (%) 
16-SEP-19 77 56.2%
 
01-OCT-19 60 43.8%
 
Max length9
Mean length9
Min length9
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

UNDERLYING_LIMIT_AMT
Boolean

Distinct count2
Unique (%)1.5%
Missing (%)28.5%
Missing (n)39
0
98
(Missing)
39
ValueCountFrequency (%) 
0 98 71.5%
 
(Missing) 39 28.5%
 

UNDERWRITER_CODE_1
Constant

This variable is constant and should be ignored for analysis

Constant valueN

UNDERWRITER_CODE_2
Constant

This variable is constant and should be ignored for analysis

Constant valueN

ZIP_CODE_FIRST5
Constant

This variable is constant and should be ignored for analysis

Constant value0

Correlations

Missing values

Sample

First rows

AGGR_POL_TERM_LIMIT_AMTAMOUNT_CATEGORY_1_DESCAMOUNT_CATEGORY_2_DESCAMOUNT_CATEGORY_3_DESCANNUAL_STMT_LINE_NAIC_CODEBLANKET_COVERAGE_INDBUREAU_LINE_CODEBUREAU_REPORTING_MODULEBUSINESS_ACTIVITY_CODECANCEL_NO_RENEW_REASON_CODECANCELLATION_TYPECHANGE_WRITTEN_PREMIUMCLAIMS_MADE_INDCLASS_CODECMRCL_DEREG_EXEMPT_INDCOMPANY_CODECONSTRUCTION_TYPECOUNTRY_CODECOVERAGE_CODECOVERAGE_INCEPTION_DATECURRENT_PROFIT_CENTERDEDUCT_AMTDEDUCT_APPLIES_TODEDUCTIBLE_CODEDEDUCTIBLE_PURPOSE_DESCEARN_EXPIRATION_DATEEXPENSE_MODIFIEREXPIRATION_DATEEXPOSUREHSB_COVERAGE_CDINSURED_CITY_STATEINSURED_NAMEINSURED_ZIPCODEINTERNAL_ANNUAL_STMT_LINE_CODEINTERNAL_ANNUAL_STMT_LINE_CODE_1ISO_PREMIUM_TERROR_CDISO_REPORTING_TERRITORY_CDISO_UNDERLYING_CDLEGACY_PRO_CDLOCATION_UNIT_NUMBERLOSS_COST_MODIFIERMINOR_LINE_CODENAICS_CODENO_OF_FAMILIESNY_FREE_TRADE_ZONE_CDONCORE_INDICATORONSET_INDPACKAGE_CODEPACKAGE_MODIFICATION_FACTORPARENT_BUSN_CVRG_CDPER_OCCUR_LIMIT_AMTPOL_LIMIT_AMTPOLICY_EFFECTIVE_DATEPOLICY_MODULEPOLICY_NUMBERPOLICY_STATEPOLICY_STATUSPOLICY_SYMBOLPOLICY_TERMPOLICY_VERSION_CDPREM_BILLING_CATEGORY_41_CODEPREM_TRNSCTN_CATEGORY_35_CODEPREMIUM_TRNSCTN_DAC_CODEPRODUCER_A_CODEPRODUCT_VALUE_1_8_CODEPROTECTION_CODERATE_BASISRATE_DEPARTURE_FACTORRATE_MOD_FACTOR_EXPENSERATE_MOD_FACTOR_IRPM_SRPRATE_MOD_FACTOR_PACKAGERATING_METHODRATING_TERRITORY_CDREIN_TYPE_REPORTING_CATEGORY_1RISK_CATG_CDSBP_BLANKET_INDSCHEDULE_MODIFIERSIC_CODESTAT_FORMAT_CODESTATE_PROVINCE_CODESUBLINE_CODESUBMISSION_IDSURCHARGE_TYPESYSTEM_OF_RECORD_CODETAX_LOCATION_CODETERRORISM_CVRG_CDTRANS_TYPE_CODETRANSACTION_ACCOUNTING_MONTHTRANSACTION_ACCOUNTING_YEARTRANSACTION_EFFECTIVE_DATEUNDERLYING_LIMIT_AMTUNDERWRITER_CODE_1UNDERWRITER_CODE_2ZIP_CODE_FIRST5
0NaNPremiumWrittenNaN90NaN61Inland MarineNBP0NON CANCEL00379010CANIMBRRES16-SEP-1935420.001NaN16-SEP-20NaN16-SEP-2000TORONTO, ONBETA UAT PM QA TEST111 BBB9090NaNNaN2.0D0NaN9023622010BRIDGE-PAS126NaNIMBRNaNNaN16-SEP-190250901882INFORCEIMP120MO12643032626AA040NaN0000NaNNaNDirectJOBSITE0NaN1542000DUIMAB920950041NaNBRIDGE-PAS0TERROR119201916-SEP-19NaNNN0
10.0PremiumWrittenNaN90NaN61Inland MarineNBP0NON CANCEL66370379013CANIMBRRES16-SEP-19354225000.0All Losses11(none)16-SEP-20NaN16-SEP-2070010TORONTO, ONBETA UAT PM QA TEST111 BBB9090NaNNaN2.0D1NaN9023622010BRIDGE-PAS126NaNIMBR0.07000999.016-SEP-190250901882INFORCEIMP120MO12643032626AA040Other0000(none)NaNDirectJOBSITE0NaN1542000DUIMAB920950041NaNBRIDGE-PAS0TERROR119201916-SEP-190.0NN0
20.0PremiumWrittenNaN90NaN61Inland MarineNBP0NON CANCEL00379010CANERROROM16-SEP-1935420.001NaN16-SEP-20NaN16-SEP-20500TORONTO, ONBETA UAT PM QA TEST111 BBB9090NaNNaN2.0D0NaN9023622010BRIDGE-PAS126NaNIMBRRENV0.050000.016-SEP-190250901882INFORCEIMP120MO12643032626AA040NaN0000NaNNaNDirectCOVPROP0NaN1542000DUIMAB920950041NaNBRIDGE-PAS0TERROR119201916-SEP-190.0NN0
30.0PremiumWrittenNaN90NaN61Inland MarineNBP0NON CANCEL00379010CANTEMPLOC16-SEP-1935420.001NaN16-SEP-20NaN16-SEP-201000TORONTO, ONBETA UAT PM QA TEST111 BBB9090NaNNaN2.0D0NaN9023622010BRIDGE-PAS126NaNIMBRPLUS0.0100000.016-SEP-190250901882INFORCEIMP120MO12643032626AA040NaN0000NaNNaNDirectCOVPROP0NaN1542000DUIMAB920950041NaNBRIDGE-PAS0TERROR119201916-SEP-190.0NN0
40.0PremiumWrittenNaN90NaN61Inland MarineNBP0NON CANCEL00379010CANTEMPSTRTR16-SEP-1935420.001NaN16-SEP-20NaN16-SEP-201000TORONTO, ONBETA UAT PM QA TEST111 BBB9090NaNNaN2.0D0NaN9023622010BRIDGE-PAS126NaNIMBRPLUS0.0100000.016-SEP-190250901882INFORCEIMP120MO12643032626AA040NaN0000NaNNaNDirectCOVPROP0NaN1542000DUIMAB920950041NaNBRIDGE-PAS0TERROR119201916-SEP-190.0NN0
5NaNPremiumWrittenNaN90NaN61Inland MarineNBP0NON CANCEL00379010CANTE16-SEP-1935420.001NaN16-SEP-20NaN16-SEP-2000TORONTO, ONBETA UAT PM QA TEST111 BBB9090NaNNaN2.0D0NaN9023622010BRIDGE-PAS126NaNIMBRPLUSNaNNaN16-SEP-190250901882INFORCEIMP120MO12643032626AA040NaN0000NaNNaNDirectTIMELEMENT0NaN1542000DUIMAB920950041NaNBRIDGE-PAS0TERROR119201916-SEP-19NaNNN0
60.0PremiumWrittenNaN90NaN61Inland MarineNBP0NON CANCEL00379010CANGREEN16-SEP-1935420.001NaN16-SEP-20NaN16-SEP-202500TORONTO, ONBETA UAT PM QA TEST111 BBB9090NaNNaN2.0D0NaN9023622010BRIDGE-PAS126NaNIMBR0.0250000.016-SEP-190250901882INFORCEIMP120MO12643032626AA040NaN0000NaNNaNDirectJOBSITE0NaN1542000DUIMAB920950041NaNBRIDGE-PAS0TERROR119201916-SEP-190.0NN0
70.0PremiumWrittenNaN90NaN61Inland MarineNBP0NON CANCEL00379010CANTREES16-SEP-1935420.001NaN16-SEP-20NaN16-SEP-201000TORONTO, ONBETA UAT PM QA TEST111 BBB9090NaNNaN2.0D0NaN9023622010BRIDGE-PAS126NaNIMBRRES0.0100000.016-SEP-190250901882INFORCEIMP120MO12643032626AA040NaN0000NaNNaNDirectCOVPROP0NaN1542000DUIMAB920950041NaNBRIDGE-PAS0TERROR119201916-SEP-190.0NN0
80.0PremiumWrittenNaN90NaN61Inland MarineNBP0NON CANCEL00379010CANREMOVALEXP16-SEP-1935420.001NaN16-SEP-20NaN16-SEP-201000TORONTO, ONBETA UAT PM QA TEST111 BBB9090NaNNaN2.0D0NaN9023622010BRIDGE-PAS126NaNIMBRPLUS0.0100000.016-SEP-190250901882INFORCEIMP120MO12643032626AA040NaN0000NaNNaNDirectCOVPROP0NaN1542000DUIMAB920950041NaNBRIDGE-PAS0TERROR119201916-SEP-190.0NN0
90.0PremiumWrittenNaN90NaN61Inland MarineNBP0NON CANCEL00379010CANSCAFFOLDS16-SEP-1935420.001NaN16-SEP-20NaN16-SEP-201000TORONTO, ONBETA UAT PM QA TEST111 BBB9090NaNNaN2.0D0NaN9023622010BRIDGE-PAS126NaNIMBRPLUS0.0100000.016-SEP-190250901882INFORCEIMP120MO12643032626AA040NaN0000NaNNaNDirectCOVPROP0NaN1542000DUIMAB920950041NaNBRIDGE-PAS0TERROR119201916-SEP-190.0NN0

Last rows

AGGR_POL_TERM_LIMIT_AMTAMOUNT_CATEGORY_1_DESCAMOUNT_CATEGORY_2_DESCAMOUNT_CATEGORY_3_DESCANNUAL_STMT_LINE_NAIC_CODEBLANKET_COVERAGE_INDBUREAU_LINE_CODEBUREAU_REPORTING_MODULEBUSINESS_ACTIVITY_CODECANCEL_NO_RENEW_REASON_CODECANCELLATION_TYPECHANGE_WRITTEN_PREMIUMCLAIMS_MADE_INDCLASS_CODECMRCL_DEREG_EXEMPT_INDCOMPANY_CODECONSTRUCTION_TYPECOUNTRY_CODECOVERAGE_CODECOVERAGE_INCEPTION_DATECURRENT_PROFIT_CENTERDEDUCT_AMTDEDUCT_APPLIES_TODEDUCTIBLE_CODEDEDUCTIBLE_PURPOSE_DESCEARN_EXPIRATION_DATEEXPENSE_MODIFIEREXPIRATION_DATEEXPOSUREHSB_COVERAGE_CDINSURED_CITY_STATEINSURED_NAMEINSURED_ZIPCODEINTERNAL_ANNUAL_STMT_LINE_CODEINTERNAL_ANNUAL_STMT_LINE_CODE_1ISO_PREMIUM_TERROR_CDISO_REPORTING_TERRITORY_CDISO_UNDERLYING_CDLEGACY_PRO_CDLOCATION_UNIT_NUMBERLOSS_COST_MODIFIERMINOR_LINE_CODENAICS_CODENO_OF_FAMILIESNY_FREE_TRADE_ZONE_CDONCORE_INDICATORONSET_INDPACKAGE_CODEPACKAGE_MODIFICATION_FACTORPARENT_BUSN_CVRG_CDPER_OCCUR_LIMIT_AMTPOL_LIMIT_AMTPOLICY_EFFECTIVE_DATEPOLICY_MODULEPOLICY_NUMBERPOLICY_STATEPOLICY_STATUSPOLICY_SYMBOLPOLICY_TERMPOLICY_VERSION_CDPREM_BILLING_CATEGORY_41_CODEPREM_TRNSCTN_CATEGORY_35_CODEPREMIUM_TRNSCTN_DAC_CODEPRODUCER_A_CODEPRODUCT_VALUE_1_8_CODEPROTECTION_CODERATE_BASISRATE_DEPARTURE_FACTORRATE_MOD_FACTOR_EXPENSERATE_MOD_FACTOR_IRPM_SRPRATE_MOD_FACTOR_PACKAGERATING_METHODRATING_TERRITORY_CDREIN_TYPE_REPORTING_CATEGORY_1RISK_CATG_CDSBP_BLANKET_INDSCHEDULE_MODIFIERSIC_CODESTAT_FORMAT_CODESTATE_PROVINCE_CODESUBLINE_CODESUBMISSION_IDSURCHARGE_TYPESYSTEM_OF_RECORD_CODETAX_LOCATION_CODETERRORISM_CVRG_CDTRANS_TYPE_CODETRANSACTION_ACCOUNTING_MONTHTRANSACTION_ACCOUNTING_YEARTRANSACTION_EFFECTIVE_DATEUNDERLYING_LIMIT_AMTUNDERWRITER_CODE_1UNDERWRITER_CODE_2ZIP_CODE_FIRST5
1270.0PremiumWrittenNaN90NaN61Inland MarineENDT0NON CANCEL00379010CANGREEN16-SEP-1935420.001NaN16-SEP-20NaN16-SEP-202500TORONTO, ONBETA UAT PM QA TEST111 BBB9090NaNNaN2.0D0NaN9023622010BRIDGE-PAS126NaNIMBR0.0250000.016-SEP-190250901882INFORCEIMP120ME12643032626AA040NaN0000NaNNaNDirectJOBSITE0NaN1542000DUIMAB920957051NaNBRIDGE-PAS0TERROR1110201901-OCT-190.0NN0
1280.0PremiumWrittenNaN90NaN61Inland MarineENDT0NON CANCEL00379010CANTEMPSTRTR16-SEP-1935420.001NaN16-SEP-20NaN16-SEP-201000TORONTO, ONBETA UAT PM QA TEST111 BBB9090NaNNaN2.0D0NaN9023622010BRIDGE-PAS126NaNIMBRPLUS0.0100000.016-SEP-190250901882INFORCEIMP120ME12643032626AA040NaN0000NaNNaNDirectCOVPROP0NaN1542000DUIMAB920957051NaNBRIDGE-PAS0TERROR1110201901-OCT-190.0NN0
1290.0PremiumWrittenNaN90NaN61Inland MarineENDT0NON CANCEL2500379010CANADDLIVEXP16-SEP-1935420.001NaN16-SEP-20NaN16-SEP-20100TORONTO, ONBETA UAT PM QA TEST111 BBB9090NaNNaN2.0D0NaN9023622010BRIDGE-PAS126NaNIMBRRES0.010000.016-SEP-190250901882INFORCEIMP120ME12643032626AA040NaN0000NaNNaNDirectCOVPROP0NaN1542000DUIMAB920957051NaNBRIDGE-PAS0TERROR1110201901-OCT-190.0NN0
1300.0PremiumWrittenNaN90NaN61Inland MarineENDT0NON CANCEL00379010CANTEMPLOC16-SEP-1935420.001NaN16-SEP-20NaN16-SEP-201000TORONTO, ONBETA UAT PM QA TEST111 BBB9090NaNNaN2.0D0NaN9023622010BRIDGE-PAS126NaNIMBRPLUS0.0100000.016-SEP-190250901882INFORCEIMP120ME12643032626AA040NaN0000NaNNaNDirectCOVPROP0NaN1542000DUIMAB920957051NaNBRIDGE-PAS0TERROR1110201901-OCT-190.0NN0
1310.0PremiumWrittenNaN90NaN61Inland MarineENDT0NON CANCEL00379010CANSCAFFOLDS16-SEP-1935420.001NaN16-SEP-20NaN16-SEP-201000TORONTO, ONBETA UAT PM QA TEST111 BBB9090NaNNaN2.0D0NaN9023622010BRIDGE-PAS126NaNIMBRPLUS0.0100000.016-SEP-190250901882INFORCEIMP120ME12643032626AA040NaN0000NaNNaNDirectCOVPROP0NaN1542000DUIMAB920957051NaNBRIDGE-PAS0TERROR1110201901-OCT-190.0NN0
132NaNPremiumWrittenNaN90NaN61Inland MarineENDT0NON CANCEL00379010CANBMP16-SEP-1935420.001NaN16-SEP-20NaN16-SEP-2000TORONTO, ONBETA UAT PM QA TEST111 BBB9090NaNNaN2.0D0NaN9023622010BRIDGE-PAS126NaNIMBRUILOBNaNNaN16-SEP-190250901882INFORCEIMP120ME12643032626AA040NaN0000NaNNaNDirectBROPS0NaN1542000DUIMAB920957051NaNBRIDGE-PAS0TERROR1210201901-OCT-19NaNNN0
1330.0PremiumWrittenNaN90NaN61Inland MarineENDT0NON CANCEL470379010CANSOFTCOST16-SEP-193542NaNEach Loss1(none)16-SEP-20NaN16-SEP-2000TORONTO, ONBETA UAT PM QA TEST111 BBB9090NaNNaN2.0D0NaN9023622010BRIDGE-PAS126NaNTE0.0100000.016-SEP-190250901882INFORCEIMP120ME12643032626AA040NaN0000NaNNaNDirectTIMELEMENT0NaN1542000DUIMAB920957051NaNBRIDGE-PAS0TERROR1110201901-OCT-190.0NN0
134NaNPremiumWrittenNaN90NaN61Inland MarineENDT0NON CANCEL00379010CANTERROR16-SEP-1935420.001NaN16-SEP-20NaN16-SEP-2000TORONTO, ONBETA UAT PM QA TEST111 BBB9090NaNNaNNaND0NaN9023622010BRIDGE-PAS122NaNIMBRUILOBNaNNaN16-SEP-190250901882INFORCEIMP120ME12643032626AA040NaN0000NaNNaNDirectBROPS0NaN1542000DUIMAB920957051NaNBRIDGE-PAS0TERROR1110201901-OCT-19NaNNN0
135NaNPremiumWrittenNaN90NaN61Inland MarineENDT0NON CANCEL00379010CANTE16-SEP-1935420.001NaN16-SEP-20NaN16-SEP-2000TORONTO, ONBETA UAT PM QA TEST111 BBB9090NaNNaN2.0D0NaN9023622010BRIDGE-PAS126NaNIMBRPLUSNaNNaN16-SEP-190250901882INFORCEIMP120ME12643032626AA040NaN0000NaNNaNDirectTIMELEMENT0NaN1542000DUIMAB920957051NaNBRIDGE-PAS0TERROR1110201901-OCT-19NaNNN0
136NaNPremiumWrittenNaN90NaN61Inland MarineENDT0NON CANCEL00379010CANIMBRRES16-SEP-1935420.001NaN16-SEP-20NaN16-SEP-2000TORONTO, ONBETA UAT PM QA TEST111 BBB9090NaNNaN2.0D0NaN9023622010BRIDGE-PAS126NaNIMBRNaNNaN16-SEP-190250901882INFORCEIMP120ME12643032626AA040NaN0000NaNNaNDirectJOBSITE0NaN1542000DUIMAB920957051NaNBRIDGE-PAS0TERROR1110201901-OCT-19NaNNN0